SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE Procedure [dbo].[TvShow_Get_ComingSoon]
AS
select top 30 E.Id AS EpisodeId, T.Title AS ShowName, Season, EpisodeId AS Episode,
E.Title AS EpisodeName, E.AirDate AS AirDate
from tvshow_episodes E
inner join Tvshow_Seasons S on S.SeasonId = E.SeasonId
inner join Tv T on T.Id = S.TvId
Where E.airdate + 2 >= GetDate() 
order by E.airdate asc
select * from tvshow_episodes
GO
